Editing Database User General

The General tab allows you to set database user properties which are:

User Name
Set name of the database user.

User Type
Select the type for this database user.

Login
Specifies the SQL Server login for which the database user is being created.

Login Name
Assign SQL Server login that this database user uses. When this SQL Server login enters the database, it will retrieve the information of this database user.

Default Schema
In SQL Server 2005 or above, you can specify the first schema that will be searched by the server for this database user.

Certificate
Specifies the certificate for which the database user is being created.

Certificate Name
Specify the certificate for this database user.

Asymmetric Key
Specifies the asymmetric key for which the database user is being created.

Asymmetric Key Name
Specify the asymmetric key for this database user.

Without Login
Specifies this database user not be mapped to an existing login.

Default Schema
In SQL Server 2005 or above, you can specify the first schema that will be searched by the server for this database user.